﻿CREATE TYPE [flcr].[DEVICE_UDT] AS  TABLE (
    [DEVICE_ID]          INT              NULL,
    [AUDIT_USER]         VARCHAR (100)    NULL,
    [AUDIT_DTTM]         DATETIME         NULL,
    [AUDIT_DTTM_TZ]      INT              NULL,
    [AUDIT_MOD_USER]     VARCHAR (100)    NULL,
    [AUDIT_MOD_DTTM]     DATETIME         NULL,
    [AUDIT_MOD_DTTM_TZ]  INT              NULL,
    [RLS_MASK]           VARBINARY (256)  NULL,
    [RLS_OWNER]          UNIQUEIDENTIFIER NULL,
    [WRKFL_ITEM_ID]      INT              NULL,
    [WRKFL_STATUS_ID]    INT              NULL,
    [ACTIVE_FLG]         BIT              NULL,
    [DEVICE_ASSET_NAME]  VARCHAR (100)    NULL,
    [DEVICE_SERIAL_NUM]  VARCHAR (100)    NULL,
    [DEVICE_ASSET_TAG]   VARCHAR (100)    NULL,
    [PARENT_ID]          INT              NULL,
    [DEVICE_TYPE]        INT              NULL,
    [DEVICE_PLATFORM_ID] INT              NULL,
    [DOMAIN_ID]          INT              NULL,
    [ORG_ID]             INT              NULL,
    [RESOURCE_ID]        INT              NULL,
    [SLA_ID]             INT              NULL,
    [FACILITY_ID]        INT              NULL,
    [ENV_ID]             INT              NULL);

